Field (Split Data)

Type

Size

Validation

Precision

Import Type

Transaction Type

Char

2

 BP, BR, CP, CR, JC, JD, PA, PC, PI, SA, SC, SI, VP, VR

Standard / Extended

Sales / Purchase / Bank Account Ref

Char

8

Lookup

Standard / Extended

Nominal Code

Char

8

Lookup

Standard / Extended

Department Number

Int

3

1 - 999

Standard / Extended

Transaction Date

Date

10

Date

Standard / Extended

Transaction (Invoice) Reference

Char

8

Standard / Extended

Transaction Details

Char

60

Standard / Extended

Net Amount

Double

11

8 digits + 2 d.p.

Standard / Extended

Tax Code

Int

2

T0 û T99

Standard / Extended

Tax Amount

Double

11

8 digits + 2 d.p.

Standard / Extended

Extra Reference

Char

8

Extended

User Name

Char

32

Extended